<?PHP
/* Generieke definitie file */
include_once '/defs/constants.php';


require DIR_INCLUDE.('connect.php');


/* Taal specifieke tekst */

include_once DIR_LANGUAGE.'nl/general.php';

include_once DIR_CLASS.FILE_TICKETSYSTEEM;

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="style_admin.css" rel="stylesheet" type="text/css" />
<title>MinEvents - Ticketoverzicht</title>
</head>

<body>
<!-- begin wrapper_achtergrond -->	<div class="wrapper_achtergrond">
<!-- begin wrapper--> 				<div class="wrapper">

<!-- begin header-->				<div class="header">

<!-- begin header_logo-->			<div class="header_logo">
<!-- einde header_logo-->			</div>


<!-- begin header_menu-->			<div class="header_menu">

<!-- begin header_instellingen-->	<div class="header_instellingen">
									<a href="#"><img src="images/instellingen.png" /></a>
<!-- einde header_instellingen-->	</div>

<!-- begin header_instellingen-->	<div class="header_FAQ">
									<a href="#"><img src="images/faq.png" /></a>
<!-- einde header_instellingen-->	</div>

<!-- begin header_instellingen-->	<div class="header_uitloggen">
									<a href="#"><img src="images/uitloggen.png" /></a>
<!-- einde header_instellingen-->	</div>

<!-- einde header_menu-->			</div>

<!-- einde header-->				</div>

									<div class="sidebar">

									<div class="home_button">
                                    <a href="../index.php"><img src="images/home_button.png" /></a>
                                    </div>

									<div class="kleine_button_1">
                                    <div class="kleine_button_1_titel"><a href="Ticketformulier_Admin.php">Ticketformulier</a></div>
									</div>
                                    

									<div class="kleine_button_2">
                                    <div class="kleine_button_2_titel"><a href="Ticketoverzicht_Admin.php">Ticketoverzicht</a></div>
									</div>

									<div class="kleine_button_3">
                                    <div class="kleine_button_3_titel"><a href="EigenTickets_Admin.html">Eigen tickets</a></div>
									</div>
                                    
                                    </div>

<div class="content">
<font size="+2"> Ticketoverzicht</font>
<br /><br />


<table width="50%" cellpadding="2" cellspacing="0"  >
	<tr><b></b></tr><tr>
	<tr>
		<td><b>Ticket Nummer:</b></td>
		<td><b>Ticket Beschrijving:</b></td>
                <td><b>Ticket Voortgang:</b></td>
                 <td><b>Ticket Titel:</b></td>
<?php
	$query = "SELECT * FROM ticketsysteem ";
	$result = mysql_query($query) or die(mysql_error());
	
	while ($loop = mysql_fetch_assoc($result)) 
	{ 
        $ticket_id = $loop['ticket_id'];
	$ticket_titel = $loop['ticket_titel'];
	$ticket_desc = $loop['ticket_beschrijving'];
	$ticket_prog = $loop['ticket_progress'];
        
	$aantal = mysql_num_rows($result);

	
		if ($aantal == '0') {
		echo "Er staat niets in de database";
		} else 	{
?>
			<tr>
				<td><a href="ticketoverzicht.php?ticketsysteem&ticket_id=<?php echo $loop['ticket_id']; ?>" name="ticket_id"><?php echo $loop['ticket_id'];?></a>
                               </td>
				<td><?php echo$loop['ticket_beschrijving'];?></td>
                                <td><?php echo$loop['ticket_progress'];?></td>
                                <td><?php echo$loop['ticket_titel'];?></td>
			</tr>
<?php
				}
	}
        
    
?>
		
	</tr>

</div>

<div class="footer">
Realisatie: Stichting Innovision Solutions
</div>
<!-- einde footer -->				</div>
<!-- einde wrapper -->				</div>
<!-- einde wrapper_achtergrond -->
</body>
</html>
